//user_status单一的user_status表SQL-Command
var UserSQL = {  
  register:"INSERT INTO sys_user(id,username,password) VALUES(REPLACE(uuid(),'-', ''),?,?)", //注册添加用户名密码
  queryUser:'SELECT * FROM sys_user WHERE username = ? ',  //用户表中查用户名是否存在
  getSid:'SELECT * FROM session_id WHERE session_id = ? ',  //查找session_id是否存在
  getUser:'select * from session_id where username = ?' ,    //查找session_id中的用户名
  updateSid:'update session_id set session_id = ? where username = ?',//更新session_id中的id
  insertSession:'insert into session_id (session_id,username) values(?,?)' //新增sessionID username
};
module.exports = UserSQL;

